| : DB1BTicket |
|
| Database Profile Data Tables Table Contents |
| Property | Description |
|---|
| Name | DB1BTicket |
| Description | This table contains summary ticket-level data from the Origin and Destination Survey (DB1B), which is a 10% sample of airline tickets from reporting carriers. It includes such items as the reporting carrier, number of passengers, ticket fare, and total miles flown for each itinerary, as well as information about whether the itinerary was domestic or round-trip. This table is related to both the O&D Segment and Market files by the unique Itinerary ID on each record. |
| Records | 364,322,128 |
| Fields | 25 |
| First Year | 1993 |
| Last Year | 2023 |
| Frequency | Quarterly |
| Latest Available Data | December, 2023 |
| | |
| Terms | Definitions |
| Airport Code | A three character alpha-numeric code issued by the U.S. Department of Transportation which is the official designation of the airport. The airport code is not always unique to a specific airport because airport codes can change or can be reused. |
| Airport ID | An identification number assigned by US DOT to identify a unique airport. Use this field for airport analysis across a range of years because an airport can change its airport code and airport codes can be reused. |
| City Market ID | An identification number assigned by US DOT to identify a city market. Use this field to consolidate airports serving the same city market. |
| Reporting Carrier | The carrier that submitted data to the Office of Airline Information for a given passenger segment. |
| Total Itinerary Yield | Itinerary fare per itinerary miles flown. The itinerary includes all segements of a journey from origin to destination. |
| Track | The actual flight path of an aircraft over the surface of the earth. |
| World Area Code (WAC) | Numeric codes used to identify geopolitical areas such as countries, states (U.S.), provinces (Canada), and territories or possessions of certain countries. The codes are used within the various data banks maintained by the Office of Airline Information (OAI) and are created by OAI. |
| | |
|
